Creating Interviewee Activity - Page 4 of the dashboard
24
Creating Interviewee- Page 4 of the dashboard
Duplicate the KPI Overview page and delete everything except the Interviewee NPS and Interviewee Score KPI cards and rename the page to Interviewee Activity. Then change the name in the text box as Interviewee Activity Dashboard, and move the colaberry logo to top left side and align it as shown in the screenshot below.

Creating Scattered Plot:

Step 1: In Fields 
- Select the scattered plot icon from the visualization panel.
- Select Interviewer from Interviewer Dim table to Details
- Select IntervieweeScore from the Measure table to X-Axis
- Select Interviewee NPS from Measure table to Y-Axis
- Select Interviewee from Interviewee Dim table to Size
- Select Year Month from Date table to Play Axis
Step 2: In Format Tool. 
- X axis
- Start Auto, End 2
- Text size 9
- Font Family - Segoe UI
- Title text size - 12
- Title OFF
- Everything else remains the same.
- Y axis
- Start -120, End 120
- Title ON
- Everything else same as above (X axis)
- Data Color:
- Format by - Field value
- Based on field - ScatterColorInterviewee from the Measure table.
- Category ON
- Title ON and renamed to "Interviewee NPS & Score by Interviewer."
- Background ON
- Color - White, and Transparency - 0
- Tooltip ON
- Visual header ON


Step 3: In Analytics 
- X-Axis Constant Line 1 click + add
- Value 0.8
- Transparency 50
- Line style - Dashed
- Position - In front
- Y-Axis Constant Line 1 click + add
- Value 55
- Everything else same as above (X-Axis)

Step 4: Adding the Rolling 12Months
- Select Filters panel.
- Drag and drop Rolloing12Month from the Date table to the area that says "Add data fields here" as shown in the screenshot.
- On the Filter type, select Basic filtering and select 1

after that go to filter pane click on expand button next to the Interviewer, select basic filtering, click on select all and then uncheck (Blank) as shown in the screenshot to avoid blanks in the report.

When you are done putting all these together, you will have something like this.
Scatter plot with play button:
https://www.youtube.com/watch?v=64-eK-tdTPc
Creating Interviewee Activity - Page 4 of the dashboard
24
Creating Interviewee- Page 4 of the dashboard
Duplicate the KPI Overview page and delete everything except the Interviewee NPS and Interviewee Score KPI cards and rename the page to Interviewee Activity. Then change the name in the text box as Interviewee Activity Dashboard, and move the colaberry logo to top left side and align it as shown in the screenshot below.

Creating Scattered Plot:

Step 1: In Fields 
- Select the scattered plot icon from the visualization panel.
- Select Interviewer from Interviewer Dim table to Details
- Select IntervieweeScore from the Measure table to X-Axis
- Select Interviewee NPS from Measure table to Y-Axis
- Select Interviewee from Interviewee Dim table to Size
- Select Year Month from Date table to Play Axis
Step 2: In Format Tool. 
- X axis
- Start Auto, End 2
- Text size 9
- Font Family - Segoe UI
- Title text size - 12
- Title OFF
- Everything else remains the same.
- Y axis
- Start -120, End 120
- Title ON
- Everything else same as above (X axis)
- Data Color:
- Format by - Field value
- Based on field - ScatterColorInterviewee from the Measure table.
- Category ON
- Title ON and renamed to "Interviewee NPS & Score by Interviewer."
- Background ON
- Color - White, and Transparency - 0
- Tooltip ON
- Visual header ON


Step 3: In Analytics 
- X-Axis Constant Line 1 click + add
- Value 0.8
- Transparency 50
- Line style - Dashed
- Position - In front
- Y-Axis Constant Line 1 click + add
- Value 55
- Everything else same as above (X-Axis)

Step 4: Adding the Rolling 12Months
- Select Filters panel.
- Drag and drop Rolloing12Month from the Date table to the area that says "Add data fields here" as shown in the screenshot.
- On the Filter type, select Basic filtering and select 1

after that go to filter pane click on expand button next to the Interviewer, select basic filtering, click on select all and then uncheck (Blank) as shown in the screenshot to avoid blanks in the report.

When you are done putting all these together, you will have something like this.
Scatter plot with play button:
https://www.youtube.com/watch?v=64-eK-tdTPc